﻿CREATE TABLE [dbo].[Recycler_Orders] (
    [id]              INT              NOT NULL,
    [OId]             UNIQUEIDENTIFIER NOT NULL,
    [OrderId]         NVARCHAR (50)    NOT NULL,
    [CustomerId]      NVARCHAR (50)    NOT NULL,
    [CustomerName]    NVARCHAR (50)    NULL,
    [ContactPerson]   NVARCHAR (50)    NULL,
    [ContactPhone]    NVARCHAR (50)    NULL,
    [UserName]        NVARCHAR (50)    NULL,
    [EName]           NVARCHAR (50)    NULL,
    [FixtureDate]     DATETIME         NULL,
    [Description]     VARCHAR (MAX)    NULL,
    [Aggregateamount] NUMERIC (18, 2)  NULL,
    [Proceeds]        NUMERIC (18, 2)  NULL,
    [CreateDate]      DATETIME         NULL,
    [CompanyId]       INT              NULL,
    [FinanceFlag]     BIT              NULL,
    [ProjectFlag]     BIT              NULL,
    [PaymentTypeId]   INT              NULL,
    [ProductId]       INT              NULL,
    [DepartmentId]    INT              NULL,
    [BaiDuAccount]    NVARCHAR (50)    NULL,
    [MainProjectId]   INT              NULL,
    [IsReason]        BIT              NULL,
    CONSTRAINT [PK_Recycler_Orders] PRIMARY KEY CLUSTERED ([id] ASC)
);

